﻿CREATE PROCEDURE [dbo].[kp_GiayToKemTheoSelectAll]	
AS
	SELECT	T1.[Ma_LoaiGt],
			Ten_LoaiGt,
			T1.Ghi_Chu,
			T2.Ghi_Chu Ghi_Chu2,
			Ma_DoiTuong,
			T1.Loai_DoiTuong,
			T1.Vi_Tri,
			ISNULL(T1.Bat_Buoc,0) Bat_Buoc
	FROM	tblGiayToKemTheo T1 
			INNER JOIN tblDmLoaiGt T2 
				ON	T1.Ma_LoaiGt=T2.Ma_LoaiGt 
RETURN 0;